create external table jms_dm.dm_sqs_fresh_call_sum_dt 
(
disp_agent_code                                        string COMMENT '派件_代理区编码' ,
disp_agent_name                                        string COMMENT '派件_代理区名称' ,
disp_site_code                                         string COMMENT '派件_网点名称' ,
disp_site_name                                         string COMMENT '派件_网点名称' ,
disp_city_id                                           string COMMENT '派件_城市' ,
disp_city_desc                                         string COMMENT '派件_城市name' ,
disp_area_id                                           string COMMENT '派件_区县' ,
disp_area_desc                                         string COMMENT '派件_区县name' ,
disp_zone_code                                         string COMMENT '派件_市场区name' ,
disp_zone_name                                         string COMMENT '派件_市场区name' ,
  fresh_num                      bigint COMMENT '生鲜总票数' ,
  complaint_num                  bigint COMMENT '客诉票数' ,
  call_total_num                 bigint COMMENT '电联票数' ,
  call_true_num                  bigint COMMENT '已接通的票数' ,
  call_this_num                  bigint COMMENT '已接通本方挂断' ,
  call_opposite_num                  bigint COMMENT '已接通对方挂断' ,
date_time                                        timestamp COMMENT 'date_time' ,
dt                                                     string COMMENT 'dt' )
comment 'insert overwrite table jms_dm.dm_sqs_fresh_call_sum_dt partition (dt)'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_sqs_fresh_call_sum_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
